<!--#include file="lib/utf-8.asp"-->
<!--#include file="lib/conn.asp"-->
<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=utf-8">
<link rel="stylesheet" href="lib/sheet.css" type="text/css">
<title>无标题文档</title>
</head>

<body>
<%
call CheckRights(3,3)
%>
<%
if request.Form("area")<>"" then area=request.Form("area")
if request.Form("dd")<>"" then dd=request.Form("dd")
if request.Form("xx")<>"" then xx=request.Form("xx")
	yj=trim(replace(request.form("yj"),"'","''"))
	if yj="" Or Not IsNumeric(yj) then yj=0
	jsj=trim(replace(request.form("jsj"),"'","''"))
	if jsj="" Or Not IsNumeric(jsj) then jsj=0
	zdrlf=trim(replace(request.form("zdrlf"),"'","''"))
	if zdrlf="" Or Not IsNumeric(zdrlf) then zdrlf=0
	zdglf=trim(replace(request.form("zdglf"),"'","''"))
	if zdglf="" Or Not IsNumeric(zdglf) then zdglf=0
	chanzhi=trim(replace(request.form("chanzhi"),"'","''"))
	if chanzhi="" Or Not IsNumeric(chanzhi) then chanzhi=0
If (CStr(Request.form("mm_add")) <> "") Then
	set cmd=Server.CreateObject("ADODB.Command")
	cmd.ActiveConnection = conn
	sql="insert into yj(area,didian,xiangxing,yunjia,jsj,zdrlf,zdglf,chanzhi) values('"&area&"','"&dd&"','"&xx&"',"&yj&","&jsj&","&zdrlf&","&zdglf&","&chanzhi&")"
	'response.write(sql)

	cmd.CommandText = sql
	cmd.Execute
	cmd.ActiveConnection.Close
	view_url="manage_yj.asp"
	response.Redirect(view_url)

end if
%>
<div class="navbar">
	<a href="manage_yj.asp">运价信息管理</a>&gt;&gt;<a href="add_yj.asp">添加运价</a>&gt;&gt;
</div>

<form name="form1" method="post" action="#">
<table cellspacing="1" cellpadding="2" border="0" bgcolor="black" width="100%">
	<tr bgcolor="silver">
		<th>区域</th>
		<th>地点</th>
		<th>箱型</th>
		<th>应收运价</th>
		<th>应付运价</th>
		<th>指导燃料费</th>
		<th>指导过路费</th>
		<th>产值</th>
	</tr>
	<tr align="center" bgcolor="#efefef">
		<td><input name="area" type="text"></td>
		<td><input name="dd" type="text"></td>
		<td>
		<select name="xx">
        <option value="40">40</option>
        <option value="20">20</option>
        <option value="45">45</option>
		</select>
		</td>
		<td><input name="yj" type="text"></td>
		<td><input name="jsj" type="text"></td>
		<td><input name="zdrlf" type="text"></td>
		<td><input name="zdglf" type="text"></td>
		<td><input name="chanzhi" type="text"></td>
	</tr>
	<tr bgcolor="silver">
		<td colspan="8" align="center"><input type="submit" name="Submit" value="提交">&nbsp;&nbsp;&nbsp;&nbsp;<input type="reset" name="Reset" value="重置"><input type="hidden" name="mm_add" value="true"></td>
	</tr>
</table>
</form>
</body>
</html>

